df=sqlContext.sql("""

    select
        *
    FROM
        dw.sms_log
    WHERE
        msg_content like '%鞋%'
        OR msg_content like '%阿迪达斯%'
        OR msg_content like '%三叶草%'
        OR msg_content like '%新百伦%'
        OR msg_content like '%NB%'
        OR msg_content like '%nb%'
        OR msg_content like '%耐克%'
        OR msg_content like '%nike%'
        OR msg_content like '%NIKE%'
        OR msg_content like '%耐克%'
        OR msg_content like '%阿迪%'
        OR msg_content like '%运动%'
        OR msg_content like '%VALENTINO BOUNCE%'
        OR msg_content like '%网鞋%'
        OR msg_content like '%运动鞋%'
        OR msg_content like '%VALENTINO BOUNCE%'
        OR msg_content like '%Under Armour%'
        OR msg_content like '%百丽%'
        OR msg_content like '%匡威%'
        OR msg_content like '%特步%'
        OR msg_content like '%安踏%'
        OR msg_content like '%Anta%'
        OR msg_content like '%美职棒%'
        OR msg_content like '%耐乔%'
        OR msg_content like '%范斯%'
        OR msg_content like '%纽巴伦%'
        OR msg_content like '%乔丹%'
        OR msg_content like '%new balance%'
        OR msg_content like '%New Balance%'
        OR msg_content like '%ANTA%'
        OR msg_content like '%aj1%'

""")
df.repartition(1).write.mode("overwrite").orc("/user/hive/warehouse/dahai.db/xie/" )

